| SyStudentNI |
| Logical Entity Name | SyStudentNI |
| Default Table Name | SyStudentNI |
| Physical Only | NO |
| Definition | |
| Note |
| SyStudentNI Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
SyStudentID |
int | NO | ||
AdEnrollID |
int | YES | ||
DSOSyStaffID |
int | YES | ||
SyVisaCode |
char(8) | YES | ||
| SEVISID | varchar(11) | YES | ||
| ProgStartDate | datetime | YES | ||
| ProgEndDate | datetime | YES | ||
| COA | money | NO | ||
| TransStatus | char(1) | YES | ||
| EnrollStatus | char(1) | YES | ||
| TaxID | char(9) | YES | ||
CountryOfBirth |
char(2) | YES | ||
CountryOfLPR |
char(2) | YES | ||
CountryOfCitizenship |
char(2) | YES | ||
| TerminateReason | char(6) | YES | ||
| Remarks | varchar(250) | YES | ||
| ProgRemarks | varchar(250) | YES | ||
| FormNumber | varchar(30) | YES | ||
| EduLevel | char(2) | YES | ||
| Major | char(7) | YES | ||
| Minor | char(7) | YES | ||
| ProofOfHealth | bit | NO | ||
| HealthProvider | varchar(60) | YES | ||
| HealthEndDate | datetime | YES | ||
| InsuranceCost | money | NO | ||
| FormPurpose | char(1) | YES | ||
| TransferFrom | varchar(100) | YES | ||
Position |
char(3) | YES | ||
| EngProfRequired | bit | NO | ||
| EngProfMet | bit | NO | ||
| NoEPReqReason | varchar(500) | YES | ||
| SchoolFund | money | NO | ||
| SchoolFundDescription | varchar(60) | YES | ||
| OtherFund | money | NO | ||
| OtherFundDescrip | varchar(60) | YES | ||
| Employment | money | NO | ||
| EmploymentDescrip | varchar(60) | YES | ||
| UsGovtAg1 | char(6) | YES | ||
| UsGovtAg2 | char(6) | YES | ||
| UsGovtAgFund1 | money | NO | ||
| UsGovtAgFund2 | money | NO | ||
| UsIntlAg1 | char(6) | YES | ||
| UsIntlAg2 | char(6) | YES | ||
| UsIntlAgFund1 | money | NO | ||
| UsIntlAgFund2 | money | NO | ||
| Personalfund | money | NO | ||
| BiNatCommFund | money | NO | ||
| NonImGvmtFund | money | NO | ||
| FundRemarks | varchar(250) | YES | ||
| PassportNum | varchar(40) | YES | ||
| PassportCountry | char(2) | YES | ||
| PassportExp | datetime | YES | ||
| VisaNum | varchar(40) | YES | ||
| VisaDate | datetime | YES | ||
| VisaPost | varchar(50) | YES | ||
| VisaExp | datetime | YES | ||
| I94 | varchar(40) | YES | ||
| I94Exp | datetime | YES | ||
| I94DS | bit | NO | ||
| PortOfEntry | varchar(50) | YES | ||
| DateofEntry | datetime | YES | ||
| Comments | varchar(2000) | YES | ||
| OffCampusPrintReq | bit | NO | ||
| OffCampusEmploymentType | char(2) | YES | ||
| OffCampusRecommendation | varchar(250) | YES | ||
| CPTPrintReq | bit | NO | ||
| CPTApplicationDate | datetime | YES | ||
| CPTApprovalDate | datetime | YES | ||
| CPTEmploymentStartDate | datetime | YES | ||
| CPTEmploymentEndDate | datetime | YES | ||
CPTEmployerID |
int | YES | ||
| CPTCourseRelevance | varchar(200) | YES | ||
| OPTPrintReq | bit | NO | ||
| OPTApplicationDate | datetime | YES | ||
| OPTApprovalDate | datetime | YES | ||
| OPTEmploymentStartDate | datetime | YES | ||
| OPTEmploymentEndDate | datetime | YES | ||
OPTEmployerID |
int | YES | ||
| OPTCourseRelevance | varchar(200) | YES | ||
| AuthReason | char(2) | YES | ||
| AuthStartDate | datetime | YES | ||
| AuthEndDate | datetime | YES | ||
| DBFRemarks | varchar(250) | YES | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
UserID |
int | NO | ||
| Ts | timestamp | NO | ||
| LivingExpense | money | NO | ||
| OtherExpense | money | NO | ||
| OtherExpenseDescrip | varchar(60) | YES | ||
| Category | char(3) | YES | ||
| SessionStartDate | datetime | YES | ||
| SessionEndDate | datetime | YES | ||
| Commuter | bit | NO | ||
| CriminalConviction | bit | NO | ||
| EVMatriculation | char(2) | YES | ||
| InfractionType | char(3) | YES | ||
| BirthCity | varchar(100) | YES | ||
| CRMSuppressFlag | bit | NO | ||
SyStudentNIID |
int | NO | ||
| Major2 | char(7) | YES |
| SyStudentNI Primary and Unique Keys |
| Key Name | Key Type | Keys |
| SyStudentNI_SyStudentID_U_C_IDX | Index | SyStudentID |
| PK_SyStudentNI | PrimaryKey | SyStudentNIID |
| SyStudentNI Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| AdEnroll | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_AdEnrollID_AdEnroll_AdEnrollID | AdEnrollID | NO | YES | ||
| SySEVISCountry | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_CountryOfBirth_SySEVISCountry_Code | CountryOfBirth | NO | YES | ||
| SySEVISCountry | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_CountryOfCitizenship_SySEVISCountry_Code | CountryOfCitizenship | NO | YES | ||
| SySEVISCountry | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_CountryOfLPR_SySEVISCountry_Code | CountryOfLPR | NO | YES | ||
| PlEmployer | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_CPTEmployerID_PlEmployer_PlEmployerID | CPTEmployerID | NO | YES | ||
| SyStaff | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_DSOSyStaffID_SyStaff_SyStaffID | DSOSyStaffID | NO | YES | ||
| PlEmployer | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_OPTEmployerID_PlEmployer_PlEmployerID | OPTEmployerID | NO | YES | ||
| SySEVISPosition | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_Position_SySEVISPosition_Code | Position | NO | YES | ||
| syStudent | Non-Identifying | One To Zero or More | FK_SyStudentNI_SyStudentID_syStudent_SyStudentID | SyStudentID | NO | YES | ||
| SyVisa | Non-Identifying | Zero or One to Zero or More | FK_SyStudentNI_SyVisaCode_SyVisa_Code | SyVisaCode | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_SyStudentNI_UserID_SyStaff_SyStaffID | UserID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| SyStudentNI Check Constraints |
| Check Constraint Name | CheckConstraint |
| Chk_SyStudentNI_USIntlAgFund1 | ([UsIntlAg1] is not null or [UsIntlAgFund1] = 0) |
| Chk_SyStudentNI_UsGovtAgFund2 | ([UsGovtAg2] is not null or [UsGovtAgFund2] = 0) |
| Chk_SyStudentNI_USGovtAgFund1 | ([UsGovtAg1] is not null or [UsGovtAgFund1] = 0) |
| Chk_SyStudentNI_AuthStartDate | ([AuthStartDate] <= [AuthEndDate]) |
| Chk_SyStudentNI_OPTEmploymentStartDate | ([OPTEmploymentStartDate] <= [OPTEmploymentEndDate]) |
| Chk_SyStudentNI_OPTApplicationDate | ([OPTApplicationDate] <= [OPTApprovalDate]) |
| Chk_SyStudentNI_CPTEmploymentStartDate | ([CPTEmploymentStartDate] <= [CPTEmploymentEndDate]) |
| Chk_SyStudentNI_CPTApplicationDate | ([CPTApplicationDate] <= [CPTApprovalDate]) |
| Chk_SyStudentNI_ProgStartDate | ([ProgStartDate] <= [ProgEndDate]) |
| Chk_SyStudentNI_EngProfRequired_EngProfMet | ([EngProfRequired] = 1 and [EngProfMet] = 0 or [EngProfRequired] = 1 and [EngProfMet] = 1 or [EngProfRequired] = 0 and [EngProfMet] = 0) |
| Chk_SyStudentNI_UsIntlAgFund2 | ([UsIntlAg2] is not null or [UsIntlAgFund2] = 0) |